package com.atguigu.gmall.realtime.bean;

import lombok.Data;

import java.math.BigDecimal;

/**
 * Author: Felix
 * Date: 2021/2/5
 * Desc: 订单明细实体类
 */
@Data
public class OrderDetail {
    Long id;
    Long order_id ;
    Long sku_id;
    BigDecimal order_price ;
    Long sku_num ;
    String sku_name;
    String create_time;
    BigDecimal split_total_amount;
    BigDecimal split_activity_amount;
    BigDecimal split_coupon_amount;
    Long create_ts;
}

/*
    CREATE TABLE `order_detail` (
        `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
        `order_id` bigint(20) DEFAULT NULL COMMENT '订单编号',
        `sku_id` bigint(20) DEFAULT NULL COMMENT 'sku_id',
        `sku_name` varchar(200) DEFAULT NULL COMMENT 'sku名称（冗余)',
        `img_url` varchar(200) DEFAULT NULL COMMENT '图片名称（冗余)',
        `order_price` decimal(10,2) DEFAULT NULL COMMENT '购买价格(下单时sku价格）',
        `sku_num` varchar(200) DEFAULT NULL COMMENT '购买个数',
        `create_time` datetime DEFAULT NULL COMMENT '创建时间',
        `source_type` varchar(20) DEFAULT NULL COMMENT '来源类型',
        `source_id` bigint(20) DEFAULT NULL COMMENT '来源编号',
        `split_total_amount` decimal(16,2) DEFAULT NULL,
        `split_activity_amount` decimal(16,2) DEFAULT NULL,
        `split_coupon_amount` decimal(16,2) DEFAULT NULL,
        PRIMARY KEY (`id`)
        ) ENGINE=InnoDB AUTO_INCREMENT=79374 DEFAULT CHARSET=utf8 COMMENT='订单明细表';
 */
